Update the server name in the databases

Distributed System Note: Complete these steps on the Database Server.

To update the server name in the ION_Data, ION_Network, and ApplicationModules databases:

1. Open SQL Server Management Studio, select File > Open File, then select the update_server_name_in_live_databases.sql script in the ...\SBS Upgrade Package\SQL_Script_Files folder.
2. Edit the script to provide the old and new server names.

   

3. Save the script and then click !Execute to update the server name in the databases.
4. Verify that the script worked by looking in ION_Data.dbo.Source table. The LOGINSERTER source should now show the new server name.

Note: For any archived databases, complete steps 1 to 3 above, but use the update_server_name_in_archive_databases.sql script instead. Repeat these steps for each archived database.